package wan.com.templateproject.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import wan.com.templateproject.entity.People;

import java.util.List;

/**
 * @author wan
 * @version 1.0.0
 * @Description people数据库dao层
 * @createTime 2021年08月17日 14:13:48
 */
@Mapper
public interface PeopleMapper {

    List<People> getPeople(@Param("name") String name, @Param("age") Integer age, @Param("num") Integer num);

    @Select("<script>" +
            " SELECT * FROM t_people WHERE id = 1" +
            "</script>")
    List<People> getPeoples();

    int updatePeople(@Param("people") People people);

    int addPeople(@Param("people") People people);
}
